Loading…
Back To Schedule
Wednesday, May 18 • 11:50am - 12:40pm
Avoid PostgreSQL LWLock:buffer_content locks in Amazon Aurora: Tips and best practices

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback form is now closed.
We have seen PostgreSQL customers facing buffer_content locks caused by contention of data in high concurrency or large datasets(96vCPUs, 768GiB with 30TB). We provide a benchmark and share tips with a real-world workload that leads to buffer_lock contentions. We then propose the patterns to minimize the chance for buffer_content locks.
Speakers
avatar for Sami Imseih

Sami Imseih

Database Engineer, Amazon Web Services
Sami Imseih is a Database Engineer specialized in PostgreSQL at AWS. Sami has been overseeing mission critical database environments for over a decade. Since 2019, Sami has been helping customers achieve success with database migrations to Amazon RDS for PostgreSQL.
avatar for Yahav Biran

Yahav Biran

Principal Solutions Architect, Amazon Web Services
Yahav Biran is a Principal Solutions Architect at AWS, focused on game tech at scale. Yahav enjoys contributing to open-source projects and publishes in the AWS blog and academic journals. He currently contributes to the K8s Helm community, Percona Live, AWS databases and compute... Read More →

Wednesday May 18, 2022 11:50am - 12:40pm CDT
Classroom 203 M2
  PostgreSQL 1

Attendees (17)